Pandas Profiling Report

Dataset statistics

Number of variables	42
Number of observations	122696
Missing cells	1036359
Missing cells (%)	20.1%
Total size in memory	36.0 MiB
Average record size in memory	308.0 B

Variable types

Text	27
Numeric	9
Boolean	4
Unsupported	2

Alerts

`site_id` has constant value ""	Constant
`promotions` has constant value ""	Constant
`shipping_store_pick_up` has constant value ""	Constant
`installments_rate` has constant value ""	Constant
`installments_currency_id` has constant value ""	Constant
`transactions_period` has constant value ""	Constant
`accepts_mercadopago` is highly imbalanced (57.8%)	Imbalance
`condition` has 2512 (2.0%) missing values	Missing
`catalog_product_id` has 72249 (58.9%) missing values	Missing
`price` has 1233 (1.0%) missing values	Missing
`original_price` has 94176 (76.8%) missing values	Missing
`official_store_id` has 107401 (87.5%) missing values	Missing
`official_store_name` has 107447 (87.6%) missing values	Missing
`shipping_logistic_type` has 10083 (8.2%) missing values	Missing
`shipping_benefits` has 122696 (100.0%) missing values	Missing
`shipping_promise` has 122696 (100.0%) missing values	Missing
`installments_quantity` has 26198 (21.4%) missing values	Missing
`installments_amount` has 26198 (21.4%) missing values	Missing
`installments_rate` has 26198 (21.4%) missing values	Missing
`installments_currency_id` has 26198 (21.4%) missing values	Missing
`brand_value_name` has 19767 (16.1%) missing values	Missing
`location` has 112185 (91.4%) missing values	Missing
`seller_contact` has 112185 (91.4%) missing values	Missing
`level_id` has 10807 (8.8%) missing values	Missing
`power_seller_status` has 36130 (29.4%) missing values	Missing
`price` is highly skewed (γ1 = 21.66247958)	Skewed
`original_price` is highly skewed (γ1 = 36.80519655)	Skewed
`available_quantity` is highly skewed (γ1 = 34.47525357)	Skewed
`installments_amount` is highly skewed (γ1 = 26.52925197)	Skewed
`shipping_benefits` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`shipping_promise` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`installments_rate` has 96498 (78.6%) zeros	Zeros
`transactions_total` has 9904 (8.1%) zeros	Zeros

Reproduction

Analysis started	2024-02-26 20:14:50.842854
Analysis finished	2024-02-26 20:15:02.738667
Duration	11.9 seconds
Software version	ydata-profiling vv4.6.4
Download configuration	config.json

id
Text

Distinct	115879
Distinct (%)	94.4%
Missing	0
Missing (%)	0.0%
Memory size	958.7 KiB

Length

Max length	13
Median length	13
Mean length	12.64945067
Min length	12

Characters and Unicode

Total characters	1552037
Distinct characters	13
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	109072 ?
Unique (%)	88.9%

Sample

1st row	MCO1324022622
2nd row	MCO1271613775
3rd row	MCO1037658202
4th row	MCO1303242171
5th row	MCO889658125

Value	Count	Frequency (%)
mco1228493631	3	< 0.1%
mco1620188094	3	< 0.1%
mco1149899347	3	< 0.1%
mco1326134609	3	< 0.1%
mco2213421240	3	< 0.1%
mco1092024925	3	< 0.1%
mco1303888682	3	< 0.1%
mco2200882108	3	< 0.1%
mco1347456295	3	< 0.1%
mco1321892971	3	< 0.1%
Other values (115869)	122666	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
1	171673	11.1%
2	126265	8.1%
3	126071	8.1%
M	122696	7.9%
C	122696	7.9%
O	122696	7.9%
8	114098	7.4%
5	113389	7.3%
9	111395	7.2%
6	109379	7.0%
Other values (3)	311679	20.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1183949	76.3%
Uppercase Letter	368088	23.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	171673	14.5%
2	126265	10.7%
3	126071	10.6%
8	114098	9.6%
5	113389	9.6%
9	111395	9.4%
6	109379	9.2%
0	107726	9.1%
4	102836	8.7%
7	101117	8.5%

Uppercase Letter

Value	Count	Frequency (%)
M	122696	33.3%
C	122696	33.3%
O	122696	33.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	1183949	76.3%
Latin	368088	23.7%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	171673	14.5%
2	126265	10.7%
3	126071	10.6%
8	114098	9.6%
5	113389	9.6%
9	111395	9.4%
6	109379	9.2%
0	107726	9.1%
4	102836	8.7%
7	101117	8.5%

Latin

Value	Count	Frequency (%)
M	122696	33.3%
C	122696	33.3%
O	122696	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1552037	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	171673	11.1%
2	126265	8.1%
3	126071	8.1%
M	122696	7.9%
C	122696	7.9%
O	122696	7.9%
8	114098	7.4%
5	113389	7.3%
9	111395	7.2%
6	109379	7.0%
Other values (3)	311679	20.1%

title
Text

Distinct	110242
Distinct (%)	89.8%
Missing	0
Missing (%)	0.0%
Memory size	958.7 KiB

Length

Max length	200
Median length	190
Mean length	52.32736194
Min length	1

Characters and Unicode

Total characters	6420358
Distinct characters	148
Distinct categories	17 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	99735 ?
Unique (%)	81.3%

Sample

1st row	Pila Recargables Aa X2 Energizer 2000 Mah
2nd row	Pila Energizer Recharge Universal Aaa X 4und
3rd row	Audífonos In-ear Inalámbricos Bluetooth F9-5 Negro
4th row	Televisor Samsung Cu7000 Crystal Uhd 55 pulgadas 2023
5th row	Parlante Jbl Bluetooth Charge 5 Color Black 110v/220v

Value	Count	Frequency (%)
de	43605	4.2%
	28883	2.8%
para	18987	1.8%
en	10973	1.1%
color	10960	1.1%
a	10517	1.0%
con	8777	0.8%
y	8540	0.8%
x	7738	0.7%
negro	6767	0.7%
Other values (75967)	878287	84.9%

Most occurring characters

Value	Count	Frequency (%)
	937588	14.6%
a	564591	8.8%
o	449905	7.0%
e	433121	6.7%
r	363645	5.7%
i	321977	5.0%
l	268129	4.2%
n	254151	4.0%
t	236124	3.7%
s	217372	3.4%
Other values (138)	2373755	37.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4150392	64.6%
Space Separator	938281	14.6%
Uppercase Letter	883915	13.8%
Decimal Number	338287	5.3%
Other Punctuation	53056	0.8%
Dash Punctuation	30813	0.5%
Math Symbol	9649	0.2%
Currency Symbol	7384	0.1%
Open Punctuation	3779	0.1%
Close Punctuation	3531	0.1%
Other values (7)	1271	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	564591	13.6%
o	449905	10.8%
e	433121	10.4%
r	363645	8.8%
i	321977	7.8%
l	268129	6.5%
n	254151	6.1%
t	236124	5.7%
s	217372	5.2%
c	151743	3.7%
Other values (41)	889634	21.4%

Uppercase Letter

Value	Count	Frequency (%)
C	103822	11.7%
P	91103	10.3%
D	76772	8.7%
M	60008	6.8%
A	59994	6.8%
S	53269	6.0%
E	50104	5.7%
B	44934	5.1%
T	40091	4.5%
L	39485	4.5%
Other values (27)	264333	29.9%

Other Punctuation

Value	Count	Frequency (%)
,	18833	35.5%
.	16097	30.3%
/	10380	19.6%
:	1674	3.2%
'	1400	2.6%
%	1153	2.2%
!	1036	2.0%
&	853	1.6%
*	623	1.2%
#	487	0.9%
Other values (7)	520	1.0%

Decimal Number

Value	Count	Frequency (%)
0	82790	24.5%
1	60362	17.8%
2	50328	14.9%
5	32435	9.6%
3	26952	8.0%
4	23968	7.1%
6	19231	5.7%
8	15947	4.7%
7	13355	3.9%
9	12919	3.8%

Math Symbol

Value	Count	Frequency (%)
+	9034	93.6%
\|	516	5.3%
×	39	0.4%
=	35	0.4%
~	16	0.2%
±	8	0.1%
÷	1	< 0.1%

Other Number

Value	Count	Frequency (%)
³	31	36.9%
½	22	26.2%
²	20	23.8%
¼	11	13.1%

Open Punctuation

Value	Count	Frequency (%)
(	3532	93.5%
[	243	6.4%
{	4	0.1%

Close Punctuation

Value	Count	Frequency (%)
)	3305	93.6%
]	221	6.3%
}	5	0.1%

Other Symbol

Value	Count	Frequency (%)
®	448	58.8%
°	306	40.2%
©	8	1.0%

Modifier Symbol

Value	Count	Frequency (%)
´	219	93.2%
¨	9	3.8%
`	7	3.0%

Space Separator

Value	Count	Frequency (%)
	937588	99.9%
	693	0.1%

Currency Symbol

Value	Count	Frequency (%)
$	7383	> 99.9%
£	1	< 0.1%

Other Letter

Value	Count	Frequency (%)
ª	76	55.5%
º	61	44.5%

Dash Punctuation

Value	Count	Frequency (%)
-	30813	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	45	100.0%

Final Punctuation

Value	Count	Frequency (%)
»	5	100.0%

Format

Value	Count	Frequency (%)
	3	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5034443	78.4%
Common	1385915	21.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	564591	11.2%
o	449905	8.9%
e	433121	8.6%
r	363645	7.2%
i	321977	6.4%
l	268129	5.3%
n	254151	5.0%
t	236124	4.7%
s	217372	4.3%
c	151743	3.0%
Other values (79)	1773685	35.2%

Common

Value	Count	Frequency (%)
	937588	67.7%
0	82790	6.0%
1	60362	4.4%
2	50328	3.6%
5	32435	2.3%
-	30813	2.2%
3	26952	1.9%
4	23968	1.7%
6	19231	1.4%
,	18833	1.4%
Other values (49)	102615	7.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6360289	99.1%
None	60069	0.9%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	937588	14.7%
a	564591	8.9%
o	449905	7.1%
e	433121	6.8%
r	363645	5.7%
i	321977	5.1%
l	268129	4.2%
n	254151	4.0%
t	236124	3.7%
s	217372	3.4%
Other values (81)	2313686	36.4%

None

Value	Count	Frequency (%)
ó	13906	23.2%
á	12895	21.5%
ñ	11288	18.8%
í	9745	16.2%
é	6775	11.3%
ú	1627	2.7%
	693	1.2%
Á	639	1.1%
®	448	0.7%
°	306	0.5%
Other values (47)	1747	2.9%

condition
Text

MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	2512
Missing (%)	2.0%
Memory size	958.7 KiB

Length

Max length	13
Median length	3
Mean length	3.085468948
Min length	3

Characters and Unicode

Total characters	370824
Distinct characters	13
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	new
2nd row	new
3rd row	new
4th row	new
5th row	new

Value	Count	Frequency (%)
new	110398	91.9%
used	9732	8.1%
not_specified	54	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	120238	32.4%
n	110452	29.8%
w	110398	29.8%
s	9786	2.6%
d	9786	2.6%
u	9732	2.6%
i	108	< 0.1%
o	54	< 0.1%
t	54	< 0.1%
_	54	< 0.1%
Other values (3)	162	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	370770	> 99.9%
Connector Punctuation	54	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	120238	32.4%
n	110452	29.8%
w	110398	29.8%
s	9786	2.6%
d	9786	2.6%
u	9732	2.6%
i	108	< 0.1%
o	54	< 0.1%
t	54	< 0.1%
p	54	< 0.1%
Other values (2)	108	< 0.1%

Connector Punctuation

Value	Count	Frequency (%)
_	54	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	370770	> 99.9%
Common	54	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	120238	32.4%
n	110452	29.8%
w	110398	29.8%
s	9786	2.6%
d	9786	2.6%
u	9732	2.6%
i	108	< 0.1%
o	54	< 0.1%
t	54	< 0.1%
p	54	< 0.1%
Other values (2)	108	< 0.1%

Common

Value	Count	Frequency (%)
_	54	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	370824	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	120238	32.4%
n	110452	29.8%
w	110398	29.8%
s	9786	2.6%
d	9786	2.6%
u	9732	2.6%
i	108	< 0.1%
o	54	< 0.1%
t	54	< 0.1%
_	54	< 0.1%
Other values (3)	162	< 0.1%

catalog_product_id
Text

MISSING

Distinct	41325
Distinct (%)	81.9%
Missing	72249
Missing (%)	58.9%
Memory size	958.7 KiB

Length

Max length	13
Median length	11
Mean length	10.96986937
Min length	9

Characters and Unicode

Total characters	553397
Distinct characters	13
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	34621 ?
Unique (%)	68.6%

Sample

1st row	MCO21850181
2nd row	MCO22015422
3rd row	MCO16224063
4th row	MCO23541767
5th row	MCO17949052

Value	Count	Frequency (%)
mco18951365	20	< 0.1%
mco6107994	20	< 0.1%
mco16268158	17	< 0.1%
mco19681518	17	< 0.1%
mco21777210	16	< 0.1%
mco22238606	16	< 0.1%
mco8755482	15	< 0.1%
mco6454377	15	< 0.1%
mco18706965	15	< 0.1%
mco27216699	15	< 0.1%
Other values (41315)	50281	99.7%

Most occurring characters

Value	Count	Frequency (%)
2	68856	12.4%
M	50447	9.1%
C	50447	9.1%
O	50447	9.1%
1	48312	8.7%
7	37908	6.9%
9	36459	6.6%
0	36256	6.6%
5	36137	6.5%
3	35531	6.4%
Other values (3)	102597	18.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	402056	72.7%
Uppercase Letter	151341	27.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	68856	17.1%
1	48312	12.0%
7	37908	9.4%
9	36459	9.1%
0	36256	9.0%
5	36137	9.0%
3	35531	8.8%
4	34378	8.6%
8	34196	8.5%
6	34023	8.5%

Uppercase Letter

Value	Count	Frequency (%)
M	50447	33.3%
C	50447	33.3%
O	50447	33.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	402056	72.7%
Latin	151341	27.3%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	68856	17.1%
1	48312	12.0%
7	37908	9.4%
9	36459	9.1%
0	36256	9.0%
5	36137	9.0%
3	35531	8.8%
4	34378	8.6%
8	34196	8.5%
6	34023	8.5%

Latin

Value	Count	Frequency (%)
M	50447	33.3%
C	50447	33.3%
O	50447	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	553397	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	68856	12.4%
M	50447	9.1%
C	50447	9.1%
O	50447	9.1%
1	48312	8.7%
7	37908	6.9%
9	36459	6.6%
0	36256	6.6%
5	36137	6.5%
3	35531	6.4%
Other values (3)	102597	18.5%

listing_type_id
Text

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	958.7 KiB

Length

Max length	12
Median length	12
Mean length	10.64473169
Min length	4

Characters and Unicode

Total characters	1306066
Distinct characters	19
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	gold_special
2nd row	gold_special
3rd row	gold_special
4th row	gold_pro
5th row	gold_special

Value	Count	Frequency (%)
gold_special	74864	61.0%
gold_pro	37315	30.4%
gold_premium	8359	6.8%
free	1939	1.6%
gold	100	0.1%
bronze	82	0.1%
silver	37	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
l	195539	15.0%
o	158035	12.1%
g	120638	9.2%
d	120638	9.2%
_	120538	9.2%
p	120538	9.2%
e	87220	6.7%
i	83260	6.4%
s	74901	5.7%
c	74864	5.7%
Other values (9)	149895	11.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1185528	90.8%
Connector Punctuation	120538	9.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
l	195539	16.5%
o	158035	13.3%
g	120638	10.2%
d	120638	10.2%
p	120538	10.2%
e	87220	7.4%
i	83260	7.0%
s	74901	6.3%
c	74864	6.3%
a	74864	6.3%
Other values (8)	75031	6.3%

Connector Punctuation

Value	Count	Frequency (%)
_	120538	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1185528	90.8%
Common	120538	9.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
l	195539	16.5%
o	158035	13.3%
g	120638	10.2%
d	120638	10.2%
p	120538	10.2%
e	87220	7.4%
i	83260	7.0%
s	74901	6.3%
c	74864	6.3%
a	74864	6.3%
Other values (8)	75031	6.3%

Common

Value	Count	Frequency (%)
_	120538	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1306066	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
l	195539	15.0%
o	158035	12.1%
g	120638	9.2%
d	120638	9.2%
_	120538	9.2%
p	120538	9.2%
e	87220	6.7%
i	83260	6.4%
s	74901	5.7%
c	74864	5.7%
Other values (9)	149895	11.5%

permalink
Text

Distinct	115270
Distinct (%)	93.9%
Missing	0
Missing (%)	0.0%
Memory size	958.7 KiB

Length

Max length	361
Median length	320
Mean length	103.4472354
Min length	47

Characters and Unicode

Total characters	12692562
Distinct characters	45
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	108037 ?
Unique (%)	88.1%

Sample

1st row	https://www.mercadolibre.com.co/pila-recargables-aa-x2-energizer-2000-mah/p/MCO21850181
2nd row	https://www.mercadolibre.com.co/pila-energizer-recharge-universal-aaa-x-4und/p/MCO22015422
3rd row	https://www.mercadolibre.com.co/audifonos-in-ear-inalambricos-bluetooth-f9-5-negro/p/MCO16224063
4th row	https://www.mercadolibre.com.co/televisor-samsung-cu7000-crystal-uhd-55pulgadas-2023/p/MCO23541767
5th row	https://www.mercadolibre.com.co/parlante-jbl-bluetooth-charge-5-color-black-110v220v/p/MCO17949052

Value	Count	Frequency (%)
https://www.mercadolibre.com.co/boya-by-v1-negro/p/mco23076703	5	< 0.1%
https://www.mercadolibre.com.co/microfono-hyperx-blx-solocast-condensador-cardioide-color-negro/p/mco17481564	5	< 0.1%
https://www.mercadolibre.com.co/microfono-hyperx-quadcast-condensador-bidireccional-color-negro/p/mco15160609	5	< 0.1%
https://www.mercadolibre.com.co/audifonos-over-ear-logitech-g-series-g733-con-bluetooth-color-negro/p/mco16269735	4	< 0.1%
https://www.mercadolibre.com.co/audifonos-gamer-inalambricos-lenovo-lp7-negro/p/mco18536671	4	< 0.1%
https://www.mercadolibre.com.co/microfono-fifine-k669-condensador-cardioide-color-negro/p/mco17469532	4	< 0.1%
https://www.mercadolibre.com.co/microfono-hyperx-blx-solocast-condensador-cardioide-color-blanco/p/mco19520938	4	< 0.1%
https://www.mercadolibre.com.co/airpods-pro-2-generacion-11/p/mco19623394	4	< 0.1%
https://www.mercadolibre.com.co/microfono-razer-seiren-seiren-mini-condensador-supercardioide-color-blanco-mercurio/p/mco16650278	4	< 0.1%
https://www.mercadolibre.com.co/microfono-hyperx-quadcast-s-condensador-omnidireccional-color-black/p/mco16265275	4	< 0.1%
Other values (115260)	122653	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
-	1137801	9.0%
o	934536	7.4%
a	844255	6.7%
e	745883	5.9%
r	730832	5.8%
c	706895	5.6%
t	602805	4.7%
i	554675	4.4%
l	507016	4.0%
/	443192	3.5%
Other values (35)	5484672	43.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	8566920	67.5%
Decimal Number	1430345	11.3%
Dash Punctuation	1137801	9.0%
Other Punctuation	933976	7.4%
Uppercase Letter	538376	4.2%
Connector Punctuation	85144	0.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	934536	10.9%
a	844255	9.9%
e	745883	8.7%
r	730832	8.5%
c	706895	8.3%
t	602805	7.0%
i	554675	6.5%
l	507016	5.9%
m	415876	4.9%
s	399245	4.7%
Other values (16)	2124902	24.8%

Decimal Number

Value	Count	Frequency (%)
1	202892	14.2%
2	186377	13.0%
0	179253	12.5%
5	141202	9.9%
3	134054	9.4%
6	121592	8.5%
8	121028	8.5%
4	119979	8.4%
9	116437	8.1%
7	107531	7.5%

Uppercase Letter

Value	Count	Frequency (%)
M	207840	38.6%
C	122696	22.8%
O	122696	22.8%
J	85144	15.8%

Other Punctuation

Value	Count	Frequency (%)
/	443192	47.5%
.	368088	39.4%
:	122696	13.1%

Dash Punctuation

Value	Count	Frequency (%)
-	1137801	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	85144	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	9105296	71.7%
Common	3587266	28.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	934536	10.3%
a	844255	9.3%
e	745883	8.2%
r	730832	8.0%
c	706895	7.8%
t	602805	6.6%
i	554675	6.1%
l	507016	5.6%
m	415876	4.6%
s	399245	4.4%
Other values (20)	2663278	29.2%

Common

Value	Count	Frequency (%)
-	1137801	31.7%
/	443192	12.4%
.	368088	10.3%
1	202892	5.7%
2	186377	5.2%
0	179253	5.0%
5	141202	3.9%
3	134054	3.7%
:	122696	3.4%
6	121592	3.4%
Other values (5)	550119	15.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	12692562	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
-	1137801	9.0%
o	934536	7.4%
a	844255	6.7%
e	745883	5.9%
r	730832	5.8%
c	706895	5.6%
t	602805	4.7%
i	554675	4.4%
l	507016	4.0%
/	443192	3.5%
Other values (35)	5484672	43.2%

buying_mode
Text

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	958.7 KiB

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	1226960
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	buy_it_now
2nd row	buy_it_now
3rd row	buy_it_now
4th row	buy_it_now
5th row	buy_it_now

Value	Count	Frequency (%)
buy_it_now	112185	91.4%
classified	10511	8.6%

Most occurring characters

Value	Count	Frequency (%)
_	224370	18.3%
i	133207	10.9%
b	112185	9.1%
u	112185	9.1%
y	112185	9.1%
t	112185	9.1%
n	112185	9.1%
o	112185	9.1%
w	112185	9.1%
s	21022	1.7%
Other values (6)	63066	5.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1002590	81.7%
Connector Punctuation	224370	18.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	133207	13.3%
b	112185	11.2%
u	112185	11.2%
y	112185	11.2%
t	112185	11.2%
n	112185	11.2%
o	112185	11.2%
w	112185	11.2%
s	21022	2.1%
c	10511	1.0%
Other values (5)	52555	5.2%

Connector Punctuation

Value	Count	Frequency (%)
_	224370	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1002590	81.7%
Common	224370	18.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	133207	13.3%
b	112185	11.2%
u	112185	11.2%
y	112185	11.2%
t	112185	11.2%
n	112185	11.2%
o	112185	11.2%
w	112185	11.2%
s	21022	2.1%
c	10511	1.0%
Other values (5)	52555	5.2%

Common

Value	Count	Frequency (%)
_	224370	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1226960	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
_	224370	18.3%
i	133207	10.9%
b	112185	9.1%
u	112185	9.1%
y	112185	9.1%
t	112185	9.1%
n	112185	9.1%
o	112185	9.1%
w	112185	9.1%
s	21022	1.7%
Other values (6)	63066	5.1%

site_id
Text

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	958.7 KiB

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	368088
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	MCO
2nd row	MCO
3rd row	MCO
4th row	MCO
5th row	MCO

Value	Count	Frequency (%)
mco	122696	100.0%

Most occurring characters

Value	Count	Frequency (%)
M	122696	33.3%
C	122696	33.3%
O	122696	33.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	368088	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
M	122696	33.3%
C	122696	33.3%
O	122696	33.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	368088	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
M	122696	33.3%
C	122696	33.3%
O	122696	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	368088	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
M	122696	33.3%
C	122696	33.3%
O	122696	33.3%

category_id
Text

Distinct	3776
Distinct (%)	3.1%
Missing	0
Missing (%)	0.0%
Memory size	958.7 KiB

Length

Max length	9
Median length	9
Mean length	8.247391928
Min length	7

Characters and Unicode

Total characters	1011922
Distinct characters	13
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	691 ?
Unique (%)	0.6%

Sample

1st row	MCO7279
2nd row	MCO7279
3rd row	MCO3697
4th row	MCO14903
5th row	MCO3691

Value	Count	Frequency (%)
mco1196	3998	3.3%
mco1744	3686	3.0%
mco1176	3185	2.6%
mco8830	2063	1.7%
mco1442	1784	1.5%
mco9355	1404	1.1%
mco1474	1334	1.1%
mco435877	1222	1.0%
mco167011	1135	0.9%
mco9356	1132	0.9%
Other values (3766)	101753	82.9%

Most occurring characters

Value	Count	Frequency (%)
1	134797	13.3%
M	122696	12.1%
C	122696	12.1%
O	122696	12.1%
4	85844	8.5%
7	67316	6.7%
6	64418	6.4%
3	61718	6.1%
8	47187	4.7%
9	45895	4.5%
Other values (3)	136659	13.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	643834	63.6%
Uppercase Letter	368088	36.4%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	134797	20.9%
4	85844	13.3%
7	67316	10.5%
6	64418	10.0%
3	61718	9.6%
8	47187	7.3%
9	45895	7.1%
5	45801	7.1%
0	45585	7.1%
2	45273	7.0%

Uppercase Letter

Value	Count	Frequency (%)
M	122696	33.3%
C	122696	33.3%
O	122696	33.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	643834	63.6%
Latin	368088	36.4%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	134797	20.9%
4	85844	13.3%
7	67316	10.5%
6	64418	10.0%
3	61718	9.6%
8	47187	7.3%
9	45895	7.1%
5	45801	7.1%
0	45585	7.1%
2	45273	7.0%

Latin

Value	Count	Frequency (%)
M	122696	33.3%
C	122696	33.3%
O	122696	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1011922	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	134797	13.3%
M	122696	12.1%
C	122696	12.1%
O	122696	12.1%
4	85844	8.5%
7	67316	6.7%
6	64418	6.4%
3	61718	6.1%
8	47187	4.7%
9	45895	4.5%
Other values (3)	136659	13.5%

domain_id
Text

Distinct	2746
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Memory size	958.7 KiB

Length

Max length	58
Median length	47
Mean length	20.05476136
Min length	7

Characters and Unicode

Total characters	2460639
Distinct characters	30
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	409 ?
Unique (%)	0.3%

Sample

1st row	MCO-CELL_BATTERIES
2nd row	MCO-CELL_BATTERIES
3rd row	MCO-HEADPHONES
4th row	MCO-TELEVISIONS
5th row	MCO-SPEAKERS

Value	Count	Frequency (%)
mco-books	3998	3.3%
mco-cars_and_vans	3686	3.0%
mco-music_albums	3185	2.6%
mco-headphones	2152	1.8%
mco-supplements	2127	1.7%
mco-cats_and_dogs_foods	1887	1.5%
mco-wristwatches	1784	1.5%
mco-coins	1404	1.1%
mco-individual_apartments_for_sale	1334	1.1%
mco-balloons	1222	1.0%
Other values (2736)	99917	81.4%

Most occurring characters

Value	Count	Frequency (%)
O	239478	9.7%
C	227628	9.3%
S	216410	8.8%
E	190702	7.8%
M	177243	7.2%
A	164940	6.7%
_	163317	6.6%
R	127160	5.2%
-	122696	5.0%
I	115756	4.7%
Other values (20)	715309	29.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2174563	88.4%
Connector Punctuation	163317	6.6%
Dash Punctuation	122696	5.0%
Decimal Number	63	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
O	239478	11.0%
C	227628	10.5%
S	216410	10.0%
E	190702	8.8%
M	177243	8.2%
A	164940	7.6%
R	127160	5.8%
I	115756	5.3%
T	111595	5.1%
N	102161	4.7%
Other values (16)	501490	23.1%

Decimal Number

Value	Count	Frequency (%)
3	60	95.2%
2	3	4.8%

Connector Punctuation

Value	Count	Frequency (%)
_	163317	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	122696	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2174563	88.4%
Common	286076	11.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
O	239478	11.0%
C	227628	10.5%
S	216410	10.0%
E	190702	8.8%
M	177243	8.2%
A	164940	7.6%
R	127160	5.8%
I	115756	5.3%
T	111595	5.1%
N	102161	4.7%
Other values (16)	501490	23.1%

Common

Value	Count	Frequency (%)
_	163317	57.1%
-	122696	42.9%
3	60	< 0.1%
2	3	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2460639	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
O	239478	9.7%
C	227628	9.3%
S	216410	8.8%
E	190702	7.8%
M	177243	7.2%
A	164940	6.7%
_	163317	6.6%
R	127160	5.2%
-	122696	5.0%
I	115756	4.7%
Other values (20)	715309	29.1%

price
Real number (ℝ)

MISSING SKEWED

Distinct	27616
Distinct (%)	22.7%
Missing	1233
Missing (%)	1.0%
Infinite	0
Infinite (%)	0.0%
Mean	22944222.68

Minimum	1400
Maximum	9999999999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	958.7 KiB

Quantile statistics

Minimum	1400
5-th percentile	11500
Q1	32900
median	81500
Q3	238836
95-th percentile	41000000
Maximum	9999999999
Range	9999998599
Interquartile range (IQR)	205936

Descriptive statistics

Standard deviation	213317768.4
Coefficient of variation (CV)	9.297232312
Kurtosis	662.9662464
Mean	22944222.68
Median Absolute Deviation (MAD)	60500
Skewness	21.66247958
Sum	2.786874119 × 10¹²
Variance	4.550447034 × 10¹⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
90000	986	0.8%
39900	706	0.6%
19900	676	0.6%
29900	673	0.5%
60000	614	0.5%
70000	610	0.5%
49900	609	0.5%
50000	599	0.5%
59900	543	0.4%
35000	531	0.4%
Other values (27606)	114916	93.7%
(Missing)	1233	1.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1400	5	< 0.1%
1500	2	< 0.1%
2000	7	< 0.1%
2500	3	< 0.1%
2900	52	< 0.1%

Value	Count	Frequency (%)
9999999999	5	< 0.1%
9999000000	1	< 0.1%
9350000000	1	< 0.1%
9000000000	1	< 0.1%
8700000000	1	< 0.1%

original_price
Real number (ℝ)

MISSING SKEWED

Distinct	7624
Distinct (%)	26.7%
Missing	94176
Missing (%)	76.8%
Infinite	0
Infinite (%)	0.0%
Mean	472822.7972

Minimum	3145
Maximum	319900000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	958.7 KiB

Quantile statistics

Minimum	3145
5-th percentile	14900
Q1	39512
median	98889.5
Q3	259900
95-th percentile	1599900
Maximum	319900000
Range	319896855
Interquartile range (IQR)	220388

Descriptive statistics

Standard deviation	4351824.302
Coefficient of variation (CV)	9.203922331
Kurtosis	1722.60002
Mean	472822.7972
Median Absolute Deviation (MAD)	71890.5
Skewness	36.80519655
Sum	1.348490618 × 10¹⁰
Variance	1.893837475 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
29900	250	0.2%
49900	242	0.2%
59900	232	0.2%
89900	226	0.2%
39900	224	0.2%
99900	222	0.2%
69900	222	0.2%
19900	210	0.2%
79900	184	0.1%
199900	180	0.1%
Other values (7614)	26328	21.5%
(Missing)	94176	76.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3145	2	< 0.1%
3200	1	< 0.1%
3225	1	< 0.1%
3239	1	< 0.1%
3500	1	< 0.1%

Value	Count	Frequency (%)
319900000	1	< 0.1%
178990000	1	< 0.1%
144990000	6	< 0.1%
144900000	1	< 0.1%
142900000	1	< 0.1%

available_quantity
Real number (ℝ)

SKEWED

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	98.87530156

Minimum	1
Maximum	50000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	958.7 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	250
Maximum	50000
Range	49999
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1354.285834
Coefficient of variation (CV)	13.69690724
Kurtosis	1259.854134
Mean	98.87530156
Median Absolute Deviation (MAD)	0
Skewness	34.47525357
Sum	12131604
Variance	1834090.119
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
1	95654	78.0%
50	11621	9.5%
500	5435	4.4%
250	3146	2.6%
150	2636	2.1%
100	2573	2.1%
200	966	0.8%
5000	581	0.5%
50000	84	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	95654	78.0%
50	11621	9.5%
100	2573	2.1%
150	2636	2.1%
200	966	0.8%

Value	Count	Frequency (%)
50000	84	0.1%
5000	581	0.5%
500	5435	4.4%
250	3146	2.6%
200	966	0.8%

official_store_id
Real number (ℝ)

MISSING

Distinct	551
Distinct (%)	3.6%
Missing	107401
Missing (%)	87.5%
Infinite	0
Infinite (%)	0.0%
Mean	4671.642563

Minimum	2
Maximum	65680
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	958.7 KiB

Quantile statistics

Minimum	2
5-th percentile	153
Q1	608
median	1278
Q3	1960
95-th percentile	50047
Maximum	65680
Range	65678
Interquartile range (IQR)	1352

Descriptive statistics

Standard deviation	13242.48175
Coefficient of variation (CV)	2.834652174
Kurtosis	10.62878236
Mean	4671.642563
Median Absolute Deviation (MAD)	682
Skewness	3.529216064
Sum	71452773
Variance	175363322.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1117	550	0.4%
1278	459	0.4%
1961	398	0.3%
2059	395	0.3%
2068	372	0.3%
1287	366	0.3%
663	278	0.2%
344	272	0.2%
467	239	0.2%
535	229	0.2%
Other values (541)	11737	9.6%
(Missing)	107401	87.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	42	< 0.1%
4	28	< 0.1%
11	95	0.1%
22	114	0.1%
23	10	< 0.1%

Value	Count	Frequency (%)
65680	10	< 0.1%
65522	6	< 0.1%
64348	2	< 0.1%
63262	4	< 0.1%
62882	46	< 0.1%

official_store_name
Text

MISSING

Distinct	548
Distinct (%)	3.6%
Missing	107447
Missing (%)	87.6%
Memory size	958.7 KiB

Length

Max length	30
Median length	26
Mean length	10.04341268
Min length	2

Characters and Unicode

Total characters	153152
Distinct characters	60
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	68 ?
Unique (%)	0.4%

Sample

1st row	Energizer
2nd row	Energizer
3rd row	Samsung
4th row	Challenger
5th row	Sony

Value	Count	Frequency (%)
libreria	842	3.8%
la	759	3.4%
ferreteria	586	2.6%
croydon	550	2.5%
de	489	2.2%
u	459	2.0%
gm	398	1.8%
comunicaciones	398	1.8%
ipetplace	395	1.8%
ebook	372	1.7%
Other values (661)	17173	76.6%

Most occurring characters

Value	Count	Frequency (%)
e	13962	9.1%
a	13094	8.5%
o	12729	8.3%
r	9990	6.5%
i	8922	5.8%
	7304	4.8%
l	7064	4.6%
t	6434	4.2%
s	6265	4.1%
n	6228	4.1%
Other values (50)	61160	39.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	112640	73.5%
Uppercase Letter	32935	21.5%
Space Separator	7304	4.8%
Decimal Number	273	0.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	13962	12.4%
a	13094	11.6%
o	12729	11.3%
r	9990	8.9%
i	8922	7.9%
l	7064	6.3%
t	6434	5.7%
s	6265	5.6%
n	6228	5.5%
c	5057	4.5%
Other values (16)	22895	20.3%

Uppercase Letter

Value	Count	Frequency (%)
M	2741	8.3%
L	2487	7.6%
C	2470	7.5%
E	2211	6.7%
A	2188	6.6%
I	1943	5.9%
B	1852	5.6%
O	1822	5.5%
T	1821	5.5%
R	1626	4.9%
Other values (16)	11774	35.7%

Decimal Number

Value	Count	Frequency (%)
2	155	56.8%
1	75	27.5%
6	16	5.9%
3	14	5.1%
0	9	3.3%
4	2	0.7%
5	2	0.7%

Space Separator

Value	Count	Frequency (%)
	7304	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	145575	95.1%
Common	7577	4.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	13962	9.6%
a	13094	9.0%
o	12729	8.7%
r	9990	6.9%
i	8922	6.1%
l	7064	4.9%
t	6434	4.4%
s	6265	4.3%
n	6228	4.3%
c	5057	3.5%
Other values (42)	55830	38.4%

Common

Value	Count	Frequency (%)
	7304	96.4%
2	155	2.0%
1	75	1.0%
6	16	0.2%
3	14	0.2%
0	9	0.1%
4	2	< 0.1%
5	2	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	153152	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	13962	9.1%
a	13094	8.5%
o	12729	8.3%
r	9990	6.5%
i	8922	5.8%
	7304	4.8%
l	7064	4.6%
t	6434	4.2%
s	6265	4.1%
n	6228	4.1%
Other values (50)	61160	39.9%

accepts_mercadopago
Boolean

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	119.9 KiB

True	112185
False	10511

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	112185	91.4%
False	10511	8.6%

stop_time
Text

Distinct	20682
Distinct (%)	16.9%
Missing	0
Missing (%)	0.0%
Memory size	958.7 KiB

Length

Max length	24
Median length	24
Mean length	24
Min length	24

Characters and Unicode

Total characters	2944704
Distinct characters	15
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	16457 ?
Unique (%)	13.4%

Sample

1st row	2043-03-12T04:00:00.000Z
2nd row	2044-02-03T14:32:39.000Z
3rd row	2042-10-29T04:00:00.000Z
4th row	2043-06-01T04:00:00.000Z
5th row	2042-04-29T04:00:00.000Z

Value	Count	Frequency (%)
2043-08-17t04:00:00.000z	421	0.3%
2043-10-19t04:00:00.000z	364	0.3%
2043-07-19t04:00:00.000z	358	0.3%
2043-08-19t04:00:00.000z	335	0.3%
2043-08-03t04:00:00.000z	329	0.3%
2043-09-13t04:00:00.000z	323	0.3%
2043-08-23t04:00:00.000z	317	0.3%
2043-10-26t04:00:00.000z	317	0.3%
2043-07-22t04:00:00.000z	316	0.3%
2043-07-28t04:00:00.000z	309	0.3%
Other values (20672)	119307	97.2%

Most occurring characters

Value	Count	Frequency (%)
0	1161086	39.4%
4	265346	9.0%
-	245392	8.3%
:	245392	8.3%
2	243863	8.3%
1	149662	5.1%
T	122696	4.2%
.	122696	4.2%
Z	122696	4.2%
3	108069	3.7%
Other values (5)	157806	5.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2085832	70.8%
Other Punctuation	368088	12.5%
Dash Punctuation	245392	8.3%
Uppercase Letter	245392	8.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1161086	55.7%
4	265346	12.7%
2	243863	11.7%
1	149662	7.2%
3	108069	5.2%
5	35816	1.7%
8	31618	1.5%
7	31523	1.5%
9	31428	1.5%
6	27421	1.3%

Other Punctuation

Value	Count	Frequency (%)
:	245392	66.7%
.	122696	33.3%

Uppercase Letter

Value	Count	Frequency (%)
T	122696	50.0%
Z	122696	50.0%

Dash Punctuation

Value	Count	Frequency (%)
-	245392	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2699312	91.7%
Latin	245392	8.3%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1161086	43.0%
4	265346	9.8%
-	245392	9.1%
:	245392	9.1%
2	243863	9.0%
1	149662	5.5%
.	122696	4.5%
3	108069	4.0%
5	35816	1.3%
8	31618	1.2%
Other values (3)	90372	3.3%

Latin

Value	Count	Frequency (%)
T	122696	50.0%
Z	122696	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2944704	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1161086	39.4%
4	265346	9.0%
-	245392	8.3%
:	245392	8.3%
2	243863	8.3%
1	149662	5.1%
T	122696	4.2%
.	122696	4.2%
Z	122696	4.2%
3	108069	3.7%
Other values (5)	157806	5.4%

catalog_listing
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	119.9 KiB

False	85144
True	37552

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	85144	69.4%
True	37552	30.6%

promotions
Text

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	958.7 KiB

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	245392
Distinct characters	2
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	[]
2nd row	[]
3rd row	[]
4th row	[]
5th row	[]

Value	Count	Frequency (%)
	122696	100.0%

Most occurring characters

Value	Count	Frequency (%)
[	122696	50.0%
]	122696	50.0%

Most occurring categories

Value	Count	Frequency (%)
Open Punctuation	122696	50.0%
Close Punctuation	122696	50.0%

Most frequent character per category

Open Punctuation

Value	Count	Frequency (%)
[	122696	100.0%

Close Punctuation

Value	Count	Frequency (%)
]	122696	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	245392	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
[	122696	50.0%
]	122696	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	245392	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
[	122696	50.0%
]	122696	50.0%

category
Text

Distinct	32
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	958.7 KiB

Length

Max length	9
Median length	7
Mean length	7.328413314
Min length	7

Characters and Unicode

Total characters	899167
Distinct characters	13
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	MCO1000
2nd row	MCO1000
3rd row	MCO1000
4th row	MCO1000
5th row	MCO1000

Value	Count	Frequency (%)
mco1367	4000	3.3%
mco118204	4000	3.3%
mco175794	4000	3.3%
mco1430	4000	3.3%
mco1403	4000	3.3%
mco1368	4000	3.3%
mco1276	4000	3.3%
mco1743	4000	3.3%
mco1168	4000	3.3%
mco1747	3999	3.3%
Other values (22)	82697	67.4%

Most occurring characters

Value	Count	Frequency (%)
1	142372	15.8%
M	122696	13.6%
C	122696	13.6%
O	122696	13.6%
4	67044	7.5%
0	58775	6.5%
7	51944	5.8%
3	48598	5.4%
8	35980	4.0%
9	35963	4.0%
Other values (3)	90403	10.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	531079	59.1%
Uppercase Letter	368088	40.9%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	142372	26.8%
4	67044	12.6%
0	58775	11.1%
7	51944	9.8%
3	48598	9.2%
8	35980	6.8%
9	35963	6.8%
2	31979	6.0%
5	30446	5.7%
6	27978	5.3%

Uppercase Letter

Value	Count	Frequency (%)
M	122696	33.3%
C	122696	33.3%
O	122696	33.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	531079	59.1%
Latin	368088	40.9%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	142372	26.8%
4	67044	12.6%
0	58775	11.1%
7	51944	9.8%
3	48598	9.2%
8	35980	6.8%
9	35963	6.8%
2	31979	6.0%
5	30446	5.7%
6	27978	5.3%

Latin

Value	Count	Frequency (%)
M	122696	33.3%
C	122696	33.3%
O	122696	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	899167	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	142372	15.8%
M	122696	13.6%
C	122696	13.6%
O	122696	13.6%
4	67044	7.5%
0	58775	6.5%
7	51944	5.8%
3	48598	5.4%
8	35980	4.0%
9	35963	4.0%
Other values (3)	90403	10.1%

shipping_store_pick_up
Boolean

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	119.9 KiB

False	122696

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	122696	100.0%

shipping_free_shipping
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	119.9 KiB

False	70956
True	51740

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	70956	57.8%
True	51740	42.2%

shipping_logistic_type
Text

MISSING

Distinct	7
Distinct (%)	< 0.1%
Missing	10083
Missing (%)	8.2%
Memory size	958.7 KiB

Length

Max length	13
Median length	11
Mean length	11.45890794
Min length	6

Characters and Unicode

Total characters	1290422
Distinct characters	19
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	fulfillment
2nd row	fulfillment
3rd row	cross_docking
4th row	drop_off
5th row	xd_drop_off

Value	Count	Frequency (%)
xd_drop_off	45610	40.5%
cross_docking	38286	34.0%
fulfillment	15210	13.5%
drop_off	9413	8.4%
not_specified	3389	3.0%
custom	612	0.5%
default	93	0.1%

Most occurring characters

Value	Count	Frequency (%)
o	190619	14.8%
f	143948	11.2%
d	142401	11.0%
_	142308	11.0%
r	93309	7.2%
c	80573	6.2%
s	80573	6.2%
i	60274	4.7%
p	58412	4.5%
n	56885	4.4%
Other values (9)	241120	18.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1148114	89.0%
Connector Punctuation	142308	11.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	190619	16.6%
f	143948	12.5%
d	142401	12.4%
r	93309	8.1%
c	80573	7.0%
s	80573	7.0%
i	60274	5.2%
p	58412	5.1%
n	56885	5.0%
l	45723	4.0%
Other values (8)	195397	17.0%

Connector Punctuation

Value	Count	Frequency (%)
_	142308	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1148114	89.0%
Common	142308	11.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	190619	16.6%
f	143948	12.5%
d	142401	12.4%
r	93309	8.1%
c	80573	7.0%
s	80573	7.0%
i	60274	5.2%
p	58412	5.1%
n	56885	5.0%
l	45723	4.0%
Other values (8)	195397	17.0%

Common

Value	Count	Frequency (%)
_	142308	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1290422	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	190619	14.8%
f	143948	11.2%
d	142401	11.0%
_	142308	11.0%
r	93309	7.2%
c	80573	6.2%
s	80573	6.2%
i	60274	4.7%
p	58412	4.5%
n	56885	4.4%
Other values (9)	241120	18.7%

shipping_mode
Text

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	958.7 KiB

Length

Max length	13
Median length	3
Mean length	4.112962118
Min length	3

Characters and Unicode

Total characters	504644
Distinct characters	15
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	me2
2nd row	me2
3rd row	me2
4th row	me2
5th row	me2

Value	Count	Frequency (%)
me2	108519	88.4%
not_specified	13472	11.0%
custom	612	0.5%
me1	93	0.1%

Most occurring characters

Value	Count	Frequency (%)
e	135556	26.9%
m	109224	21.6%
2	108519	21.5%
i	26944	5.3%
o	14084	2.8%
t	14084	2.8%
s	14084	2.8%
c	14084	2.8%
n	13472	2.7%
_	13472	2.7%
Other values (5)	41121	8.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	382560	75.8%
Decimal Number	108612	21.5%
Connector Punctuation	13472	2.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	135556	35.4%
m	109224	28.6%
i	26944	7.0%
o	14084	3.7%
t	14084	3.7%
s	14084	3.7%
c	14084	3.7%
n	13472	3.5%
p	13472	3.5%
f	13472	3.5%
Other values (2)	14084	3.7%

Decimal Number

Value	Count	Frequency (%)
2	108519	99.9%
1	93	0.1%

Connector Punctuation

Value	Count	Frequency (%)
_	13472	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	382560	75.8%
Common	122084	24.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	135556	35.4%
m	109224	28.6%
i	26944	7.0%
o	14084	3.7%
t	14084	3.7%
s	14084	3.7%
c	14084	3.7%
n	13472	3.5%
p	13472	3.5%
f	13472	3.5%
Other values (2)	14084	3.7%

Common

Value	Count	Frequency (%)
2	108519	88.9%
_	13472	11.0%
1	93	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	504644	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	135556	26.9%
m	109224	21.6%
2	108519	21.5%
i	26944	5.3%
o	14084	2.8%
t	14084	2.8%
s	14084	2.8%
c	14084	2.8%
n	13472	2.7%
_	13472	2.7%
Other values (5)	41121	8.1%

shipping_tags
Text

Distinct	127
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	958.7 KiB

Length

Max length	135
Median length	132
Mean length	24.11442101
Min length	2

Characters and Unicode

Total characters	2958743
Distinct characters	37
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	24 ?
Unique (%)	< 0.1%

Sample

1st row	['fulfillment', 'self_service_out']
2nd row	['fulfillment', 'self_service_in']
3rd row	['self_service_in']
4th row	['mandatory_free_shipping']
5th row	['mandatory_free_shipping']

Value	Count	Frequency (%)
self_service_in	54449	33.7%
mandatory_free_shipping	46987	29.1%
	29448	18.2%
fulfillment	15210	9.4%
self_service_out	7682	4.8%
mco-chg-threshold-jan-23	3497	2.2%
fs_threshold_mco_change_apr2021	1182	0.7%
fs_threshold_mco_change_jul2021	1065	0.7%
fbm_in_process	816	0.5%
is_flammable	761	0.5%
Other values (8)	447	0.3%

Most occurring characters

Value	Count	Frequency (%)
e	306128	10.3%
'	264192	8.9%
_	230700	7.8%
i	228110	7.7%
s	182391	6.2%
n	170924	5.8%
r	164001	5.5%
f	143445	4.8%
[	122696	4.1%
]	122696	4.1%
Other values (27)	1023460	34.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2096446	70.9%
Other Punctuation	303040	10.2%
Connector Punctuation	230700	7.8%
Open Punctuation	122696	4.1%
Close Punctuation	122696	4.1%
Space Separator	38848	1.3%
Decimal Number	16341	0.6%
Dash Punctuation	13988	0.5%
Uppercase Letter	13988	0.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	306128	14.6%
i	228110	10.9%
s	182391	8.7%
n	170924	8.2%
r	164001	7.8%
f	143445	6.8%
l	116697	5.6%
a	103113	4.9%
p	96229	4.6%
t	75992	3.6%
Other values (12)	509416	24.3%

Decimal Number

Value	Count	Frequency (%)
2	8320	50.9%
3	3497	21.4%
1	2277	13.9%
0	2247	13.8%

Uppercase Letter

Value	Count	Frequency (%)
M	3497	25.0%
C	3497	25.0%
O	3497	25.0%
J	3497	25.0%

Other Punctuation

Value	Count	Frequency (%)
'	264192	87.2%
,	38848	12.8%

Connector Punctuation

Value	Count	Frequency (%)
_	230700	100.0%

Open Punctuation

Value	Count	Frequency (%)
[	122696	100.0%

Close Punctuation

Value	Count	Frequency (%)
]	122696	100.0%

Space Separator

Value	Count	Frequency (%)
	38848	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	13988	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2110434	71.3%
Common	848309	28.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	306128	14.5%
i	228110	10.8%
s	182391	8.6%
n	170924	8.1%
r	164001	7.8%
f	143445	6.8%
l	116697	5.5%
a	103113	4.9%
p	96229	4.6%
t	75992	3.6%
Other values (16)	523404	24.8%

Common

Value	Count	Frequency (%)
'	264192	31.1%
_	230700	27.2%
[	122696	14.5%
]	122696	14.5%
,	38848	4.6%
	38848	4.6%
-	13988	1.6%
2	8320	1.0%
3	3497	0.4%
1	2277	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2958743	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	306128	10.3%
'	264192	8.9%
_	230700	7.8%
i	228110	7.7%
s	182391	6.2%
n	170924	5.8%
r	164001	5.5%
f	143445	4.8%
[	122696	4.1%
]	122696	4.1%
Other values (27)	1023460	34.6%

shipping_benefits
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	122696
Missing (%)	100.0%
Memory size	958.7 KiB

shipping_promise
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	122696
Missing (%)	100.0%
Memory size	958.7 KiB

seller_id
Real number (ℝ)

Distinct	15025
Distinct (%)	12.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	461498176.2

Minimum	17434
Maximum	1699297072
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	958.7 KiB

Quantile statistics

Minimum	17434
5-th percentile	39810996
Q1	160820235
median	311862503
Q3	637840655
95-th percentile	1357115454
Maximum	1699297072
Range	1699279638
Interquartile range (IQR)	477020420

Descriptive statistics

Standard deviation	409887353.7
Coefficient of variation (CV)	0.8881667899
Kurtosis	0.6435667519
Mean	461498176.2
Median Absolute Deviation (MAD)	207974631.5
Skewness	1.219056842
Sum	5.662398023 × 10¹³
Variance	1.680076427 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
181939816	1094	0.9%
791273252	885	0.7%
1194088518	848	0.7%
394380898	662	0.5%
91086457	605	0.5%
313600420	551	0.4%
573609394	490	0.4%
178562922	473	0.4%
279263455	459	0.4%
438128163	426	0.3%
Other values (15015)	116203	94.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
17434	24	< 0.1%
51545	1	< 0.1%
79421	1	< 0.1%
83777	1	< 0.1%
86705	25	< 0.1%

Value	Count	Frequency (%)
1699297072	1	< 0.1%
1699214406	1	< 0.1%
1699209680	1	< 0.1%
1699183850	1	< 0.1%
1699177230	1	< 0.1%

seller_nickname
Text

Distinct	15025
Distinct (%)	12.2%
Missing	0
Missing (%)	0.0%
Memory size	958.7 KiB

Length

Max length	30
Median length	24
Mean length	15.16344461
Min length	3

Characters and Unicode

Total characters	1860494
Distinct characters	50
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8149 ?
Unique (%)	6.6%

Sample

1st row	OPERADOR TO
2nd row	OPERADOR TO
3rd row	JUAN20220131132107
4th row	SAMSUNG COLOMBIA
5th row	EGP_TECNOLOGIA

Value	Count	Frequency (%)
sas	3316	2.0%
colombia	2146	1.3%
s.a.s	1618	1.0%
store	1476	0.9%
tienda	1386	0.8%
discotienda	1094	0.7%
hitmusical	1094	0.7%
online	916	0.6%
liberimportacinsasliberimp	885	0.5%
gruporespaldoinmobiliariosa	848	0.5%
Other values (15951)	148725	91.0%

Most occurring characters

Value	Count	Frequency (%)
A	179899	9.7%
O	169352	9.1%
E	152394	8.2%
I	140471	7.6%
S	122276	6.6%
R	113704	6.1%
C	100194	5.4%
L	90424	4.9%
T	88795	4.8%
N	87960	4.7%
Other values (40)	615025	33.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1653444	88.9%
Decimal Number	131175	7.1%
Space Separator	40809	2.2%
Other Punctuation	17637	0.9%
Connector Punctuation	11980	0.6%
Dash Punctuation	5449	0.3%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	179899	10.9%
O	169352	10.2%
E	152394	9.2%
I	140471	8.5%
S	122276	7.4%
R	113704	6.9%
C	100194	6.1%
L	90424	5.5%
T	88795	5.4%
N	87960	5.3%
Other values (23)	407975	24.7%

Decimal Number

Value	Count	Frequency (%)
2	27311	20.8%
0	21519	16.4%
1	19538	14.9%
3	12207	9.3%
4	9613	7.3%
5	9362	7.1%
9	8366	6.4%
7	8009	6.1%
6	7875	6.0%
8	7375	5.6%

Other Punctuation

Value	Count	Frequency (%)
.	17629	> 99.9%
*	6	< 0.1%
:	1	< 0.1%
@	1	< 0.1%

Space Separator

Value	Count	Frequency (%)
	40809	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	11980	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	5449	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1653444	88.9%
Common	207050	11.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	179899	10.9%
O	169352	10.2%
E	152394	9.2%
I	140471	8.5%
S	122276	7.4%
R	113704	6.9%
C	100194	6.1%
L	90424	5.5%
T	88795	5.4%
N	87960	5.3%
Other values (23)	407975	24.7%

Common

Value	Count	Frequency (%)
	40809	19.7%
2	27311	13.2%
0	21519	10.4%
1	19538	9.4%
.	17629	8.5%
3	12207	5.9%
_	11980	5.8%
4	9613	4.6%
5	9362	4.5%
9	8366	4.0%
Other values (7)	28716	13.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1858994	99.9%
None	1500	0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	179899	9.7%
O	169352	9.1%
E	152394	8.2%
I	140471	7.6%
S	122276	6.6%
R	113704	6.1%
C	100194	5.4%
L	90424	4.9%
T	88795	4.8%
N	87960	4.7%
Other values (33)	613525	33.0%

None

Value	Count	Frequency (%)
Í	461	30.7%
Ñ	282	18.8%
Ó	280	18.7%
Á	232	15.5%
É	189	12.6%
Ú	52	3.5%
Ü	4	0.3%

installments_quantity
Real number (ℝ)

MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	26198
Missing (%)	21.4%
Infinite	0
Infinite (%)	0.0%
Mean	28.22234658

Minimum	12
Maximum	36
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	958.7 KiB

Quantile statistics

Minimum	12
5-th percentile	12
Q1	12
median	36
Q3	36
95-th percentile	36
Maximum	36
Range	24
Interquartile range (IQR)	24

Descriptive statistics

Standard deviation	11.23267986
Coefficient of variation (CV)	0.3980065879
Kurtosis	-1.43480783
Mean	28.22234658
Median Absolute Deviation (MAD)	0
Skewness	-0.7518124156
Sum	2723400
Variance	126.1730969
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=2)

Value	Count	Frequency (%)
36	65226	53.2%
12	31272	25.5%
(Missing)	26198	21.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
12	31272	25.5%
36	65226	53.2%

Value	Count	Frequency (%)
36	65226	53.2%
12	31272	25.5%

installments_amount
Real number (ℝ)

MISSING SKEWED

Distinct	25960
Distinct (%)	26.9%
Missing	26198
Missing (%)	21.4%
Infinite	0
Infinite (%)	0.0%
Mean	13661.45928

Minimum	546.81
Maximum	4086158.33
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	958.7 KiB

Quantile statistics

Minimum	546.81
5-th percentile	732.86
Q1	1815.1675
median	3747.22
Q3	8886.11
95-th percentile	48274.21
Maximum	4086158.33
Range	4085611.52
Interquartile range (IQR)	7070.9425

Descriptive statistics

Standard deviation	61214.09133
Coefficient of variation (CV)	4.48078716
Kurtosis	1100.19588
Mean	13661.45928
Median Absolute Deviation (MAD)	2466.66
Skewness	26.52925197
Sum	1318303497
Variance	3747164977
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2500	771	0.6%
4166.67	474	0.4%
1666.67	462	0.4%
5000	442	0.4%
1108.33	430	0.4%
7500	409	0.3%
5833.33	382	0.3%
1386.11	375	0.3%
2083.33	374	0.3%
552.78	367	0.3%
Other values (25950)	92012	75.0%
(Missing)	26198	21.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
546.81	1	< 0.1%
546.94	2	< 0.1%
547.19	2	< 0.1%
547.22	20	< 0.1%
547.42	1	< 0.1%

Value	Count	Frequency (%)
4086158.33	1	< 0.1%
3583333.33	1	< 0.1%
3453241.67	1	< 0.1%
3333333.33	1	< 0.1%
2962575	1	< 0.1%

installments_rate
Real number (ℝ)

CONSTANT MISSING ZEROS

Distinct	1
Distinct (%)	< 0.1%
Missing	26198
Missing (%)	21.4%
Infinite	0
Infinite (%)	0.0%
Mean	0

Minimum	0
Maximum	0
Zeros	96498
Zeros (%)	78.6%
Negative	0
Negative (%)	0.0%
Memory size	958.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	0
Range	0
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0
Coefficient of variation (CV)	nan
Kurtosis	0
Mean	0
Median Absolute Deviation (MAD)	0
Skewness	0
Sum	0
Variance	0
Monotonicity	Increasing

Histogram with fixed size bins (bins=1)

Value	Count	Frequency (%)
0	96498	78.6%
(Missing)	26198	21.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	96498	78.6%

Value	Count	Frequency (%)
0	96498	78.6%

installments_currency_id
Text

CONSTANT MISSING

Distinct	1
Distinct (%)	< 0.1%
Missing	26198
Missing (%)	21.4%
Memory size	958.7 KiB

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	289494
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	COP
2nd row	COP
3rd row	COP
4th row	COP
5th row	COP

Value	Count	Frequency (%)
cop	96498	100.0%

Most occurring characters

Value	Count	Frequency (%)
C	96498	33.3%
O	96498	33.3%
P	96498	33.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	289494	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	96498	33.3%
O	96498	33.3%
P	96498	33.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	289494	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	96498	33.3%
O	96498	33.3%
P	96498	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	289494	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
C	96498	33.3%
O	96498	33.3%
P	96498	33.3%

brand_value_name
Text

MISSING

Distinct	19762
Distinct (%)	19.2%
Missing	19767
Missing (%)	16.1%
Memory size	958.7 KiB

Length

Max length	214
Median length	200
Mean length	8.57925366
Min length	1

Characters and Unicode

Total characters	883054
Distinct characters	125
Distinct categories	16 ?
Distinct scripts	2 ?
Distinct blocks	4 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	11330 ?
Unique (%)	11.0%

Sample

1st row	Energizer
2nd row	Energizer
3rd row	Shenzhen Yihaotong
4th row	Samsung
5th row	JBL

Value	Count	Frequency (%)
genérica	10637	7.7%
truper	1057	0.8%
de	1044	0.8%
casio	757	0.6%
	653	0.5%
sony	631	0.5%
samsung	624	0.5%
nintendo	601	0.4%
la	566	0.4%
home	535	0.4%
Other values (18028)	120443	87.6%

Most occurring characters

Value	Count	Frequency (%)
e	72037	8.2%
a	71811	8.1%
i	57889	6.6%
o	54973	6.2%
r	54836	6.2%
n	49993	5.7%
	34765	3.9%
l	34331	3.9%
t	32871	3.7%
c	31133	3.5%
Other values (115)	388415	44.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	629790	71.3%
Uppercase Letter	207288	23.5%
Space Separator	34771	3.9%
Other Punctuation	4105	0.5%
Decimal Number	4085	0.5%
Dash Punctuation	2143	0.2%
Math Symbol	309	< 0.1%
Connector Punctuation	250	< 0.1%
Modifier Symbol	152	< 0.1%
Final Punctuation	50	< 0.1%
Other values (6)	111	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	72037	11.4%
a	71811	11.4%
i	57889	9.2%
o	54973	8.7%
r	54836	8.7%
n	49993	7.9%
l	34331	5.5%
t	32871	5.2%
c	31133	4.9%
s	30333	4.8%
Other values (37)	139583	22.2%

Uppercase Letter

Value	Count	Frequency (%)
G	17380	8.4%
S	15595	7.5%
A	14580	7.0%
C	13196	6.4%
M	12784	6.2%
E	12226	5.9%
T	12150	5.9%
P	10561	5.1%
L	9654	4.7%
O	9647	4.7%
Other values (25)	79515	38.4%

Other Punctuation

Value	Count	Frequency (%)
.	1299	31.6%
'	971	23.7%
&	841	20.5%
,	610	14.9%
/	151	3.7%
:	92	2.2%
%	64	1.6%
!	50	1.2%
*	14	0.3%
#	5	0.1%
Other values (3)	8	0.2%

Decimal Number

Value	Count	Frequency (%)
0	1016	24.9%
1	697	17.1%
3	597	14.6%
2	513	12.6%
4	311	7.6%
5	265	6.5%
6	249	6.1%
8	184	4.5%
7	164	4.0%
9	89	2.2%

Math Symbol

Value	Count	Frequency (%)
+	307	99.4%
±	1	0.3%
>	1	0.3%

Other Symbol

Value	Count	Frequency (%)
®	12	66.7%
°	4	22.2%
™	2	11.1%

Space Separator

Value	Count	Frequency (%)
	34765	> 99.9%
	6	< 0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	2142	> 99.9%
–	1	< 0.1%

Modifier Symbol

Value	Count	Frequency (%)
´	150	98.7%
`	2	1.3%

Open Punctuation

Value	Count	Frequency (%)
(	43	97.7%
[	1	2.3%

Connector Punctuation

Value	Count	Frequency (%)
_	250	100.0%

Final Punctuation

Value	Count	Frequency (%)
’	50	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	43	100.0%

Other Letter

Value	Count	Frequency (%)
º	4	100.0%

Other Number

Value	Count	Frequency (%)
²	1	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	837082	94.8%
Common	45972	5.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	72037	8.6%
a	71811	8.6%
i	57889	6.9%
o	54973	6.6%
r	54836	6.6%
n	49993	6.0%
l	34331	4.1%
t	32871	3.9%
c	31133	3.7%
s	30333	3.6%
Other values (73)	346875	41.4%

Common

Value	Count	Frequency (%)
	34765	75.6%
-	2142	4.7%
.	1299	2.8%
0	1016	2.2%
'	971	2.1%
&	841	1.8%
1	697	1.5%
,	610	1.3%
3	597	1.3%
2	513	1.1%
Other values (32)	2521	5.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	868893	98.4%
None	14108	1.6%
Punctuation	51	< 0.1%
Letterlike Symbols	2	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	72037	8.3%
a	71811	8.3%
i	57889	6.7%
o	54973	6.3%
r	54836	6.3%
n	49993	5.8%
	34765	4.0%
l	34331	4.0%
t	32871	3.8%
c	31133	3.6%
Other values (75)	374254	43.1%

None

Value	Count	Frequency (%)
é	11249	79.7%
í	704	5.0%
ó	682	4.8%
ñ	315	2.2%
á	277	2.0%
ä	214	1.5%
ú	153	1.1%
´	150	1.1%
Ñ	77	0.5%
ü	30	0.2%
Other values (27)	257	1.8%

Punctuation

Value	Count	Frequency (%)
’	50	98.0%
–	1	2.0%

Letterlike Symbols

Value	Count	Frequency (%)
™	2	100.0%

location
Text

MISSING

Distinct	6566
Distinct (%)	62.5%
Missing	112185
Missing (%)	91.4%
Memory size	958.7 KiB

Length

Max length	514
Median length	414
Mean length	338.5627438
Min length	234

Characters and Unicode

Total characters	3558633
Distinct characters	95
Distinct categories	13 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5786 ?
Unique (%)	55.0%

Sample

1st row	{'address_line': 'Cl. 181a #7-28, Bogotá, Colombia', 'zip_code': '', 'subneighborhood': None, 'neighborhood': {'id': 'TUNPQlNBTjkyNDYy', 'name': 'San Antonio Norte'}, 'city': {'id': 'TUNPQ1VTQTY3MTQ1', 'name': 'Usaquén'}, 'state': {'id': 'TUNPUEJPR1gxMDljZA', 'name': 'Bogotá D.C.'}, 'country': {'id': 'CO', 'name': 'Colombia'}, 'latitude': 4.7583128, 'longitude': -74.0261957}
2nd row	{'address_line': 'Calle 145a #13a-90, Bogotá, Colombia', 'zip_code': '', 'subneighborhood': None, 'neighborhood': {'id': 'TUNPQkNFRDEzNzQw', 'name': 'Cedritos'}, 'city': {'id': 'TUNPQ1VTQTY3MTQ1', 'name': 'Usaquén'}, 'state': {'id': 'TUNPUEJPR1gxMDljZA', 'name': 'Bogotá D.C.'}, 'country': {'id': 'CO', 'name': 'Colombia'}, 'latitude': 4.7268959, 'longitude': -74.0401792}
3rd row	{'address_line': 'Cl. 175 #15-20, Bogotá, Colombia', 'zip_code': '', 'subneighborhood': None, 'neighborhood': {'id': 'TUNPQkxBNzE0ODc', 'name': 'La Alameda'}, 'city': {'id': 'TUNPQ1VTQTY3MTQ1', 'name': 'Usaquén'}, 'state': {'id': 'TUNPUEJPR1gxMDljZA', 'name': 'Bogotá D.C.'}, 'country': {'id': 'CO', 'name': 'Colombia'}, 'latitude': 4.7553061, 'longitude': -74.0373278}
4th row	{'address_line': 'Transversal 5d, El Poblado, Medellín, Antioquia, Colombia', 'zip_code': '', 'subneighborhood': None, 'neighborhood': {'id': 'TUNPQkVMUDI3MDA0Ng', 'name': 'El Poblado'}, 'city': {'id': 'TUNPQ01FRGRjNjc4', 'name': 'Medellín'}, 'state': {'id': 'TUNPUEFOVGFiZWI3', 'name': 'Antioquia'}, 'country': {'id': 'CO', 'name': 'Colombia'}, 'latitude': 6.2058014, 'longitude': -75.5697919}
5th row	{'address_line': 'Sur', 'zip_code': '', 'subneighborhood': None, 'neighborhood': {}, 'city': {'id': 'TUNPQ0NBTDYyZDA0', 'name': 'Cali'}, 'state': {'id': 'TUNPUFZBTGExNmNjNg', 'name': 'Valle Del Cauca'}, 'country': {'id': 'CO', 'name': 'Colombia'}, 'latitude': 3.3704066, 'longitude': -76.5053344}

Value	Count	Frequency (%)
name	39420	11.7%
id	39420	11.7%
	18884	5.6%
colombia	12736	3.8%
country	10569	3.1%
city	10512	3.1%
co	10511	3.1%
state	10511	3.1%
address_line	10511	3.1%
neighborhood	10511	3.1%
Other values (17446)	163607	48.5%

Most occurring characters

Value	Count	Frequency (%)
'	542986	15.3%
	327103	9.2%
:	171632	4.8%
o	157739	4.4%
e	154582	4.3%
i	148529	4.2%
a	129429	3.6%
,	127736	3.6%
n	123396	3.5%
d	122275	3.4%
Other values (85)	1553226	43.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1527120	42.9%
Other Punctuation	874091	24.6%
Uppercase Letter	469105	13.2%
Space Separator	327103	9.2%
Decimal Number	222630	6.3%
Open Punctuation	52644	1.5%
Close Punctuation	52644	1.5%
Connector Punctuation	21029	0.6%
Dash Punctuation	12126	0.3%
Math Symbol	133	< 0.1%
Other values (3)	8	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	157739	10.3%
e	154582	10.1%
i	148529	9.7%
a	129429	8.5%
n	123396	8.1%
d	122275	8.0%
t	89032	5.8%
l	72362	4.7%
m	59752	3.9%
r	59366	3.9%
Other values (23)	410658	26.9%

Uppercase Letter

Value	Count	Frequency (%)
N	59860	12.8%
U	49232	10.5%
T	48165	10.3%
C	37860	8.1%
P	37317	8.0%
Q	29500	6.3%
M	19243	4.1%
O	19051	4.1%
D	18873	4.0%
E	16819	3.6%
Other values (19)	133185	28.4%

Other Punctuation

Value	Count	Frequency (%)
'	542986	62.1%
:	171632	19.6%
,	127736	14.6%
.	29346	3.4%
#	2312	0.3%
/	52	< 0.1%
&	20	< 0.1%
·	3	< 0.1%
\	2	< 0.1%
¿	1	< 0.1%

Decimal Number

Value	Count	Frequency (%)
1	32775	14.7%
4	28179	12.7%
7	25015	11.2%
0	23839	10.7%
5	23660	10.6%
3	22665	10.2%
6	19875	8.9%
2	18668	8.4%
8	14066	6.3%
9	13888	6.2%

Open Punctuation

Value	Count	Frequency (%)
{	52555	99.8%
(	89	0.2%

Close Punctuation

Value	Count	Frequency (%)
}	52555	99.8%
)	89	0.2%

Dash Punctuation

Value	Count	Frequency (%)
-	12122	> 99.9%
–	4	< 0.1%

Space Separator

Value	Count	Frequency (%)
	327103	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	21029	100.0%

Math Symbol

Value	Count	Frequency (%)
+	133	100.0%

Other Symbol

Value	Count	Frequency (%)
°	4	100.0%

Other Letter

Value	Count	Frequency (%)
ª	3	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1996228	56.1%
Common	1562405	43.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	157739	7.9%
e	154582	7.7%
i	148529	7.4%
a	129429	6.5%
n	123396	6.2%
d	122275	6.1%
t	89032	4.5%
l	72362	3.6%
N	59860	3.0%
m	59752	3.0%
Other values (53)	879272	44.0%

Common

Value	Count	Frequency (%)
'	542986	34.8%
	327103	20.9%
:	171632	11.0%
,	127736	8.2%
{	52555	3.4%
}	52555	3.4%
1	32775	2.1%
.	29346	1.9%
4	28179	1.8%
7	25015	1.6%
Other values (22)	172523	11.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3546508	99.7%
None	12121	0.3%
Punctuation	4	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
'	542986	15.3%
	327103	9.2%
:	171632	4.8%
o	157739	4.4%
e	154582	4.4%
i	148529	4.2%
a	129429	3.6%
,	127736	3.6%
n	123396	3.5%
d	122275	3.4%
Other values (70)	1541101	43.5%

None

Value	Count	Frequency (%)
á	6393	52.7%
í	2733	22.5%
é	1662	13.7%
ó	820	6.8%
ñ	339	2.8%
ú	120	1.0%
ü	26	0.2%
Á	13	0.1%
°	4	< 0.1%
Ñ	3	< 0.1%
Other values (4)	8	0.1%

Punctuation

Value	Count	Frequency (%)
–	4	100.0%

seller_contact
Text

MISSING

Distinct	3490
Distinct (%)	33.2%
Missing	112185
Missing (%)	91.4%
Memory size	958.7 KiB

Length

Max length	252
Median length	241
Mean length	133.2624869
Min length	123

Characters and Unicode

Total characters	1400722
Distinct characters	92
Distinct categories	10 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3145 ?
Unique (%)	29.9%

Sample

1st row	{'contact': '', 'other_info': '', 'webpage': '', 'area_code': '', 'phone': '', 'area_code2': '', 'phone2': '', 'email': ''}
2nd row	{'contact': '', 'other_info': '', 'webpage': '', 'area_code': '', 'phone': '', 'area_code2': '', 'phone2': '', 'email': ''}
3rd row	{'contact': '', 'other_info': '', 'webpage': '', 'area_code': '', 'phone': '', 'area_code2': '', 'phone2': '', 'email': ''}
4th row	{'contact': '', 'other_info': '', 'webpage': '', 'area_code': '', 'phone': '', 'area_code2': '', 'phone2': '', 'email': ''}
5th row	{'contact': 'Red Inmobiliaria', 'other_info': '', 'webpage': '', 'area_code': '', 'phone': '', 'area_code2': '', 'phone2': '', 'email': ''}

Value	Count	Frequency (%)
	78018	44.1%
contact	10513	5.9%
other_info	10511	5.9%
webpage	10511	5.9%
area_code	10511	5.9%
phone	10511	5.9%
area_code2	10511	5.9%
phone2	10511	5.9%
email	10511	5.9%
grupo	972	0.5%
Other values (2197)	13948	7.9%

Most occurring characters

Value	Count	Frequency (%)
'	336351	24.0%
	166677	11.9%
e	108749	7.8%
:	84108	6.0%
o	80476	5.7%
a	79635	5.7%
,	73621	5.3%
n	45092	3.2%
c	42961	3.1%
r	36203	2.6%
Other values (82)	346849	24.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	616868	44.0%
Other Punctuation	495213	35.4%
Space Separator	166677	11.9%
Uppercase Letter	46528	3.3%
Connector Punctuation	31533	2.3%
Decimal Number	22761	1.6%
Close Punctuation	10515	0.8%
Open Punctuation	10515	0.8%
Dash Punctuation	110	< 0.1%
Math Symbol	2	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	108749	17.6%
o	80476	13.0%
a	79635	12.9%
n	45092	7.3%
c	42961	7.0%
r	36203	5.9%
p	33733	5.5%
t	32531	5.3%
h	31711	5.1%
i	26727	4.3%
Other values (23)	99050	16.1%

Uppercase Letter

Value	Count	Frequency (%)
A	6353	13.7%
I	4842	10.4%
R	4741	10.2%
O	3711	8.0%
E	3506	7.5%
S	2849	6.1%
N	2643	5.7%
L	2444	5.3%
G	2149	4.6%
M	1804	3.9%
Other values (21)	11486	24.7%

Other Punctuation

Value	Count	Frequency (%)
'	336351	67.9%
:	84108	17.0%
,	73621	14.9%
.	995	0.2%
/	57	< 0.1%
&	32	< 0.1%
"	30	< 0.1%
#	17	< 0.1%
%	1	< 0.1%
@	1	< 0.1%

Decimal Number

Value	Count	Frequency (%)
2	21214	93.2%
3	290	1.3%
4	238	1.0%
1	228	1.0%
0	175	0.8%
8	159	0.7%
5	138	0.6%
9	124	0.5%
6	109	0.5%
7	86	0.4%

Close Punctuation

Value	Count	Frequency (%)
}	10511	> 99.9%
)	4	< 0.1%

Open Punctuation

Value	Count	Frequency (%)
{	10511	> 99.9%
(	4	< 0.1%

Space Separator

Value	Count	Frequency (%)
	166677	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	31533	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	110	100.0%

Math Symbol

Value	Count	Frequency (%)
+	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	737326	52.6%
Latin	663396	47.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	108749	16.4%
o	80476	12.1%
a	79635	12.0%
n	45092	6.8%
c	42961	6.5%
r	36203	5.5%
p	33733	5.1%
t	32531	4.9%
h	31711	4.8%
i	26727	4.0%
Other values (54)	145578	21.9%

Common

Value	Count	Frequency (%)
'	336351	45.6%
	166677	22.6%
:	84108	11.4%
,	73621	10.0%
_	31533	4.3%
2	21214	2.9%
}	10511	1.4%
{	10511	1.4%
.	995	0.1%
3	290	< 0.1%
Other values (18)	1515	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1400385	> 99.9%
None	337	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
'	336351	24.0%
	166677	11.9%
e	108749	7.8%
:	84108	6.0%
o	80476	5.7%
a	79635	5.7%
,	73621	5.3%
n	45092	3.2%
c	42961	3.1%
r	36203	2.6%
Other values (70)	346512	24.7%

None

Value	Count	Frequency (%)
Ñ	75	22.3%
ñ	64	19.0%
á	46	13.6%
í	46	13.6%
ó	39	11.6%
é	24	7.1%
Ó	13	3.9%
Í	11	3.3%
Á	9	2.7%
É	5	1.5%
Other values (2)	5	1.5%

level_id
Text

MISSING

Distinct	5
Distinct (%)	< 0.1%
Missing	10807
Missing (%)	8.8%
Memory size	958.7 KiB

Length

Max length	13
Median length	7
Mean length	7.064671237
Min length	5

Characters and Unicode

Total characters	790459
Distinct characters	19
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	5_green
2nd row	5_green
3rd row	5_green
4th row	5_green
5th row	5_green

Value	Count	Frequency (%)
5_green	109536	97.9%
3_yellow	1105	1.0%
4_light_green	1024	0.9%
2_orange	145	0.1%
1_red	79	0.1%

Most occurring characters

Value	Count	Frequency (%)
e	222449	28.1%
_	112913	14.3%
g	111729	14.1%
r	110784	14.0%
n	110705	14.0%
5	109536	13.9%
l	3234	0.4%
o	1250	0.2%
y	1105	0.1%
3	1105	0.1%
Other values (9)	5649	0.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	565657	71.6%
Connector Punctuation	112913	14.3%
Decimal Number	111889	14.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	222449	39.3%
g	111729	19.8%
r	110784	19.6%
n	110705	19.6%
l	3234	0.6%
o	1250	0.2%
y	1105	0.2%
w	1105	0.2%
i	1024	0.2%
h	1024	0.2%
Other values (3)	1248	0.2%

Decimal Number

Value	Count	Frequency (%)
5	109536	97.9%
3	1105	1.0%
4	1024	0.9%
2	145	0.1%
1	79	0.1%

Connector Punctuation

Value	Count	Frequency (%)
_	112913	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	565657	71.6%
Common	224802	28.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	222449	39.3%
g	111729	19.8%
r	110784	19.6%
n	110705	19.6%
l	3234	0.6%
o	1250	0.2%
y	1105	0.2%
w	1105	0.2%
i	1024	0.2%
h	1024	0.2%
Other values (3)	1248	0.2%

Common

Value	Count	Frequency (%)
_	112913	50.2%
5	109536	48.7%
3	1105	0.5%
4	1024	0.5%
2	145	0.1%
1	79	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	790459	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	222449	28.1%
_	112913	14.3%
g	111729	14.1%
r	110784	14.0%
n	110705	14.0%
5	109536	13.9%
l	3234	0.4%
o	1250	0.2%
y	1105	0.1%
3	1105	0.1%
Other values (9)	5649	0.7%

power_seller_status
Text

MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	36130
Missing (%)	29.4%
Memory size	958.7 KiB

Length

Max length	8
Median length	6
Mean length	6.418224245
Min length	4

Characters and Unicode

Total characters	555600
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	platinum
2nd row	platinum
3rd row	platinum
4th row	gold
5th row	platinum

Value	Count	Frequency (%)
platinum	42427	49.0%
gold	24325	28.1%
silver	19814	22.9%

Most occurring characters

Value	Count	Frequency (%)
l	86566	15.6%
i	62241	11.2%
p	42427	7.6%
a	42427	7.6%
t	42427	7.6%
n	42427	7.6%
u	42427	7.6%
m	42427	7.6%
g	24325	4.4%
o	24325	4.4%
Other values (5)	103581	18.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	555600	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
l	86566	15.6%
i	62241	11.2%
p	42427	7.6%
a	42427	7.6%
t	42427	7.6%
n	42427	7.6%
u	42427	7.6%
m	42427	7.6%
g	24325	4.4%
o	24325	4.4%
Other values (5)	103581	18.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	555600	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
l	86566	15.6%
i	62241	11.2%
p	42427	7.6%
a	42427	7.6%
t	42427	7.6%
n	42427	7.6%
u	42427	7.6%
m	42427	7.6%
g	24325	4.4%
o	24325	4.4%
Other values (5)	103581	18.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	555600	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
l	86566	15.6%
i	62241	11.2%
p	42427	7.6%
a	42427	7.6%
t	42427	7.6%
n	42427	7.6%
u	42427	7.6%
m	42427	7.6%
g	24325	4.4%
o	24325	4.4%
Other values (5)	103581	18.6%

transactions_period
Text

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	958.7 KiB

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	981568
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	historic
2nd row	historic
3rd row	historic
4th row	historic
5th row	historic

Value	Count	Frequency (%)
historic	122696	100.0%

Most occurring characters

Value	Count	Frequency (%)
i	245392	25.0%
h	122696	12.5%
s	122696	12.5%
t	122696	12.5%
o	122696	12.5%
r	122696	12.5%
c	122696	12.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	981568	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	245392	25.0%
h	122696	12.5%
s	122696	12.5%
t	122696	12.5%
o	122696	12.5%
r	122696	12.5%
c	122696	12.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	981568	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	245392	25.0%
h	122696	12.5%
s	122696	12.5%
t	122696	12.5%
o	122696	12.5%
r	122696	12.5%
c	122696	12.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	981568	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	245392	25.0%
h	122696	12.5%
s	122696	12.5%
t	122696	12.5%
o	122696	12.5%
r	122696	12.5%
c	122696	12.5%

transactions_total
Real number (ℝ)

ZEROS

Distinct	3142
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7818.862546

Minimum	0
Maximum	100481
Zeros	9904
Zeros (%)	8.1%
Negative	0
Negative (%)	0.0%
Memory size	958.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	735
median	3214
Q3	8428
95-th percentile	33239
Maximum	100481
Range	100481
Interquartile range (IQR)	7693

Descriptive statistics

Standard deviation	12751.59588
Coefficient of variation (CV)	1.630876077
Kurtosis	13.77994731
Mean	7818.862546
Median Absolute Deviation (MAD)	2991
Skewness	3.27162665
Sum	959343159
Variance	162603197.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	9904	8.1%
3786	1094	0.9%
6313	885	0.7%
29955	662	0.5%
2354	634	0.5%
51756	551	0.4%
11386	490	0.4%
47610	473	0.4%
7720	459	0.4%
7764	426	0.3%
Other values (3132)	107118	87.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	9904	8.1%
1	346	0.3%
2	180	0.1%
3	106	0.1%
4	114	0.1%

Value	Count	Frequency (%)
100481	300	0.2%
85527	380	0.3%
68661	307	0.3%
58977	159	0.1%
56205	421	0.3%

user_type
Text

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	958.7 KiB

Length

Max length	18
Median length	6
Mean length	6.26196453
Min length	5

Characters and Unicode

Total characters	768318
Distinct characters	18
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	brand
2nd row	brand
3rd row	normal
4th row	brand
5th row	normal

Value	Count	Frequency (%)
normal	102622	83.6%
brand	15010	12.2%
real_estate_agency	3516	2.9%
franchise	1228	1.0%
car_dealer	319	0.3%
branch	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
a	130047	16.9%
r	123015	16.0%
n	122377	15.9%
l	106457	13.9%
o	102622	13.4%
m	102622	13.4%
e	15930	2.1%
d	15329	2.0%
b	15011	2.0%
_	7351	1.0%
Other values (8)	27557	3.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	760967	99.0%
Connector Punctuation	7351	1.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	130047	17.1%
r	123015	16.2%
n	122377	16.1%
l	106457	14.0%
o	102622	13.5%
m	102622	13.5%
e	15930	2.1%
d	15329	2.0%
b	15011	2.0%
t	7032	0.9%
Other values (7)	20525	2.7%

Connector Punctuation

Value	Count	Frequency (%)
_	7351	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	760967	99.0%
Common	7351	1.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	130047	17.1%
r	123015	16.2%
n	122377	16.1%
l	106457	14.0%
o	102622	13.5%
m	102622	13.5%
e	15930	2.1%
d	15329	2.0%
b	15011	2.0%
t	7032	0.9%
Other values (7)	20525	2.7%

Common

Value	Count	Frequency (%)
_	7351	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	768318	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	130047	16.9%
r	123015	16.0%
n	122377	15.9%
l	106457	13.9%
o	102622	13.4%
m	102622	13.4%
e	15930	2.1%
d	15329	2.0%
b	15011	2.0%
_	7351	1.0%
Other values (8)	27557	3.6%

category_name
Text

Distinct	32
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	958.7 KiB

Length

Max length	30
Median length	21
Mean length	18.81188466
Min length	4

Characters and Unicode

Total characters	2308143
Distinct characters	49
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Electrónica, Audio y Video
2nd row	Electrónica, Audio y Video
3rd row	Electrónica, Audio y Video
4th row	Electrónica, Audio y Video
5th row	Electrónica, Audio y Video

Value	Count	Frequency (%)
y	79913	24.1%
accesorios	11995	3.6%
para	4306	1.3%
antigüedades	4000	1.2%
mercería	4000	1.2%
series	4000	1.2%
películas	4000	1.2%
música	4000	1.2%
otros	4000	1.2%
motos	4000	1.2%
Other values (54)	206902	62.5%

Most occurring characters

Value	Count	Frequency (%)
s	231237	10.0%
e	218934	9.5%
	208420	9.0%
o	178946	7.8%
a	156787	6.8%
i	132927	5.8%
r	122712	5.3%
c	107049	4.6%
t	96548	4.2%
l	84492	3.7%
Other values (39)	770091	33.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1832830	79.4%
Uppercase Letter	242900	10.5%
Space Separator	208420	9.0%
Other Punctuation	23993	1.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
s	231237	12.6%
e	218934	11.9%
o	178946	9.8%
a	156787	8.6%
i	132927	7.3%
r	122712	6.7%
c	107049	5.8%
t	96548	5.3%
l	84492	4.6%
y	83911	4.6%
Other values (20)	419287	22.9%

Uppercase Letter

Value	Count	Frequency (%)
A	35985	14.8%
C	35960	14.8%
M	27958	11.5%
R	15997	6.6%
P	15997	6.6%
B	12301	5.1%
E	12290	5.1%
J	11996	4.9%
V	11987	4.9%
O	11986	4.9%
Other values (7)	50443	20.8%

Space Separator

Value	Count	Frequency (%)
	208420	100.0%

Other Punctuation

Value	Count	Frequency (%)
,	23993	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2075730	89.9%
Common	232413	10.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
s	231237	11.1%
e	218934	10.5%
o	178946	8.6%
a	156787	7.6%
i	132927	6.4%
r	122712	5.9%
c	107049	5.2%
t	96548	4.7%
l	84492	4.1%
y	83911	4.0%
Other values (37)	662187	31.9%

Common

Value	Count	Frequency (%)
	208420	89.7%
,	23993	10.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2239890	97.0%
None	68253	3.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
s	231237	10.3%
e	218934	9.8%
	208420	9.3%
o	178946	8.0%
a	156787	7.0%
i	132927	5.9%
r	122712	5.5%
c	107049	4.8%
t	96548	4.3%
l	84492	3.8%
Other values (32)	701838	31.3%

None

Value	Count	Frequency (%)
í	23996	35.2%
é	15971	23.4%
ó	11983	17.6%
á	4303	6.3%
ú	4000	5.9%
ñ	4000	5.9%
ü	4000	5.9%

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Decimal Number

Math Symbol

Other Number

Open Punctuation

Close Punctuation

Other Symbol

Modifier Symbol

Space Separator

Currency Symbol

Other Letter

Dash Punctuation

Connector Punctuation

Final Punctuation

Format

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories